﻿
CREATE PROCEDURE [dbo].[CreateNewTool]		

AS
BEGIN
	
	SET NOCOUNT ON;

	DECLARE @toolID INT = 0;

	INSERT INTO Tool (Title) VALUES ('New toolbox tool');

	SET @toolID = SCOPE_IDENTITY();

	INSERT INTO ToolScript (ScriptNote, ToolID) VALUES ('SQL Script', @toolID);

	SELECT * FROM Tool WHERE ToolID = @toolID;

END